package com.ljh.mybatis.dao;


import com.ljh.mybatis.entity.Department;

import java.util.List;

/**
 * (Department)表数据库访问层
 *
 * @author makejava
 * @since 2020-11-09 19:03:43
 */
public interface DepartmentDao  {

    //通过id查询单条数据
    Department queryById(Integer id);
    //查询所有数据
    List<Department> selectAll();
    //逻辑删除
    void deleteUserById(Integer id);
    //新增
    void addUser(Department department);
    //根据id更新
    int updateById(Department department);
    //多表联合查询
    List<Department> selectMore();
    //根据ids删除数据
    void deleteUserByIds(Integer[] ids);
    //使用mybatis实现递归查询
    List<Department> selectD2();

    //使用PagerHelper完成分页查询
    List<Department> pageListDep();

    //根据条件查询，动态sql(if)
    List<Department> getDepCondition(Department department);
}